Without 'Threat Detection' feature enabled, the SQL database lacks proactive monitoring and alerts for suspicious activities and it makes it harder for administrators to respond quickly and effectively to potential threats, leading to data leaks, unauthorized access or other security breaches. Enabling 'Threat Detection' helps to ensure timely detection and mitigation of security risks, enhancing the overall security posture of the Azure SQL Database.
In Azure Console -
In Terraform -
For current Azure Provider versions:
For Azure Provider versions prior to 2.99.x:
References:
https://learn.microsoft.com/en-us/azure/azure-sql/?view=azuresql
https://registry.terraform.io/providers/hashicorp/azurerm/latest/docs/resources/mssql_database#threat_detection_policy